USDA NASS Data

State Crop Production Data from 1990-2021 in acres. The NASS data for each crop was downloaded by state, and trimmed into three columns in Microsoft Excel: Year, State, and Acres. The total land area of each state is noted in the GIS shapefiles. The square meter values were turned to acreages using the calculate function in an attribute table, and then the attribute table was exported to a .csv file for use in calculating the total crop area

Once the file is read in and transformed, with new percentages calculated, the data is linked to a second function that transforms the data into a matrix format for use in the creation of heatmaps and plots.

And this function uses the data matrix from the above functions, and transfers the matrix dataframe to a graphical heat map based on the crop selected.

Key State Information

North Dakota

Wisconsin

Iowa

Kansas

Major Cash Crops

Corn

Soybean

Cotton

Rice

Wheat

Winter Wheat

Spring Wheat

Durum Wheat

Other Grains

Oats

Barley

Flaxseed

Sorghum

Oil Crops

All Sunflower

Canola

Sugar Crops

Sugar Beets

Sugarcane (Harvested Sugar and Seed)

Potatoes

Potatoes

Sweet Potatoes (No 2021 Data)

Pulses and Beans

Dry Beans

Dry Peas (And Austrian Peas)

Lentils

Peanuts

Other Crops

Tobacco (Harvested Acres ONLY)

Hops

Hay

All Hay

Alfalfa Hay